Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_147

R_147

PerfService

PerfResource

PerfServiceID

 

 

R_148

R_148

Event

PerfResource

EventID

 

 

R_163

R_163

CollectionSite

Sample

CollectionSiteID

 

 

R_177

R_177

Frequency

OrderItem

FrequencyID

 

 

R_220

R_220

Referral

OrderItem

ReferralID

 

 

R_237

R_237

UserDefinition

LPerfServiceStatus

PersonID

 

 

R_259

R_259

OrderType

LOrderTypeStatus

OrderTypeID

 

 

R_260

R_260

OrderStatus

LOrderTypeStatus

OrderStatusID

 

 

R_528

R_528

Material

MaterialText

MaterialID

 

 

R_530

R_530

OrderItem

LOrderPerfServ

OrderID

 

 

R_531

R_531

PerfService

LOrderPerfServ

PerfServiceID

 

 

R_532

R_532

Patient

OrderItem

PersonID

 

 

R_533

R_533

Priority

PriorityText

PriorityID

 

 

R_535

R_535

Priority

OrderItem

PriorityID

 

 

R_536

R_536

Event

OrderItem

EventID

 

 

R_537

R_537

Material

Sample

MaterialID

 

 

R_538

R_538

Patient

Sample

Pat_PersonID

 

 

R_539

R_539

Unit

Sample

UnitID

 

 

R_557

R_557

Referral

Episode

ReferralID

 

 

R_580

R_580

Person

Sample

PersonID

 

 

R_616

R_616

PerfServiceStatus

PerfService

PerfServiceStatusID

 

 

R_639

R_639

Event

OrderItem

Eve_EventID

 

 

R_660

R_660

Event

PerfService

EventID

 

 

R_669

R_669

PerfServiceStatus

PerfServStatusText

PerfServiceStatusID

 

 

R_717

R_717

OrderStatus

OrderStatusText

OrderStatusID

 

 

R_719

R_719

OrderItem

LOrderStatus

OrderID

 

 

R_720

R_720

OrderStatus

LOrderStatus

OrderStatusID

 

 

R_730

R_730

Episode

OrderItem

EpisodeID

 

 

R_733

R_733

PerfServiceStatus

LPerfServiceStatus

PerfServiceStatusID

 

 

R_734

R_734

PerfService

LPerfServiceStatus

PerfServiceID

 

 

R_757

R_757

ICD

LOrderICD

ICDID

 

 

R_758

R_758

DiagnosisType

LOrderICD

DiagnosisTypeID

 

 

R_759

R_759

DiagnosisKind

LOrderICD

DiagnosisKindID

 

 

R_760

R_760

OrderItem

LOrderICD

OrderID

 

 

R_766

R_766

OrderType

OrderItem

OrderTypeID

 

 

R_767

R_767

OrderType

OrderTypeText

OrderTypeID

 

 

R_773

R_773

Sample

PerfService

SampleID

 

 

R_787

R_787

OrderItem

LOrderOrder

OrderID

 

 

R_788

R_788

OrderItem

LOrderOrder

Ord_OrderID

 

 

R_823

R_823

OrderItem

LEpisodeOrderItem

OrderID

 

 

R_824

R_824

Episode

LEpisodeOrderItem

EpisodeID

 

 

R_860

R_860

FormInstance

AttributeValue

FormInstanceID

 

 

R_861

R_861

FormInstance

LOrderItemFormInstance

FormInstanceID

 

 

R_862

R_862

OrderItem

LOrderItemFormInstance

OrderID

 

 

R_864

R_864

Patient

FormInstance

PersonID

 

 

R_865

R_865

PerfService

LPerfServiceFormInstance

PerfServiceID

 

 

R_866

R_866

FormInstance

LPerfServiceFormInstance

FormInstanceID

 

 

R_867

R_867

SysFct

LPerfServiceFormInstance

SysFctID

 

 

R_1094

R_1094

LPerfServiceStatus

LAttrValueHistLPerfServStat

LPerfServiceStatusID

 

 

R_1127

R_1127

ContractService

LOrderContractService

ContractServID

 

 


2